package com.devplatform.mapper.points;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.devplatform.pojo.points.UserLevel;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 86156
 * @description 针对表【user_level】的数据库操作Mapper
 * @createDate 2025-09-28 10:59:57
 * @Entity com.devplatform.pojo.UserLevel
 */
public interface UserLevelMapper extends BaseMapper<UserLevel> {

    @Select("SELECT * FROM user_level ORDER BY min_points ASC")
    List<UserLevel> selectAllLevelsOrdered();

    @Select("SELECT Level_name from user_level where level_id=#{levelId}")
    String selectLevelNameById(Integer levelId);

}




